package com.irdstudio.efp.console.service.dao;

import java.util.List;

import com.irdstudio.efp.console.service.domain.SArea;
import com.irdstudio.efp.console.service.vo.SAreaVO;

import org.apache.ibatis.annotations.Param;

/**
 * <p>DAO interface:省市区街道信息表				<p>
 * @author fuzm
 * @date 2018-09-07
 */
public interface SAreaDao {
	
	public int insertSArea(SArea sArea);
	
	public int deleteByPk(SArea sArea);
	
	public int updateByPk(SArea sArea);
	
	public SArea queryByPk(SArea sArea);
	
	public List<SArea> queryAllOwnerByPage(SAreaVO sArea);
	
	public List<SArea> queryAllCurrOrgByPage(SAreaVO sArea);
	
	public List<SArea> queryAllCurrDownOrgByPage(SAreaVO sArea);

	/**
	 * 根据区域编码查询是否是农户
	 * @param areaCode 区域编码
	 * @return >0,是农户
	 */
	int queryIsAgriCount(@Param("areaCode") String areaCode);
}
